UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VYqdBNIX5B4UwYT/xTFhfQuuOIo4GibiT5eUO+YmV3w='
WHERE
key_id = '9aa7bad630d9a8aee80c73b664d28501ec788a14f5cb1c23df619a326cea7a6e'
AND (
token = 'VYqdBNIX5B4UwYT/xTFhfQuuOIo4GibiT5eUO+YmV3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)