UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F5i6+qONgcc9nZt0neDqE3+ciPgenGXV0RFV77TdaVc='
WHERE
key_id = '4f0adc41474af1594a62bec27101fb30ae2abf4f04e9b2ed57cb1b6931181ac2'
AND (
token = 'F5i6+qONgcc9nZt0neDqE3+ciPgenGXV0RFV77TdaVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)