UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6bXl1XsVLvILNLZ0c7O/4bg1oTNORikOgGVr4e/QBYE='
WHERE
key_id = '73a96cd76faada6245a899638ac1937253a9bafa66016e21fa45477c9d5fe207'
AND (
token = '6bXl1XsVLvILNLZ0c7O/4bg1oTNORikOgGVr4e/QBYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)