UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CCUC+cMUvNtprX3mPJsWyrt55O8XBq8nkbKJJN+8ozI='
WHERE
key_id = '0e528eec2df08af3423fc96a3a411c35c23124736d40a062bef57c6b2dc3a11e'
AND (
token = 'CCUC+cMUvNtprX3mPJsWyrt55O8XBq8nkbKJJN+8ozI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)