UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7qyoqslDvY4nMlDxgGGxmj1cQci8r191pT+OMzQ3rYc='
WHERE
key_id = 'cfd9ba56319a6663cc8397f99a5fc6873ef1aac9754404f7bead2041c26f0e1a'
AND (
token = '7qyoqslDvY4nMlDxgGGxmj1cQci8r191pT+OMzQ3rYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)