UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p2q1Odaxfa7QiZrs8QToPi+QcLYavFCVHmCs6Cpw+kM='
WHERE
key_id = 'bb390bd2be06fe5143da730e9a4f8c070c08ae80bcb7f8472060c0efee020cd1'
AND (
token = 'p2q1Odaxfa7QiZrs8QToPi+QcLYavFCVHmCs6Cpw+kM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)