UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nJi56dz69s3kOkcSLrbJXKYuZSLh7P9ML7ocSqWA2WQ='
WHERE
key_id = '5ca9c9d04abe8065849b381509c8750babea324c5c35c48bf5a1f8de83b6efe7'
AND (
token = 'nJi56dz69s3kOkcSLrbJXKYuZSLh7P9ML7ocSqWA2WQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)