UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bXAvs0ws8HCVytspq7FkctfoP7KRZKZD2/FLhdIJW6U='
WHERE
key_id = '9666af364c8a4564d6d90d2b15509981109b521a4181b8da56f26869a69b480c'
AND (
token = 'bXAvs0ws8HCVytspq7FkctfoP7KRZKZD2/FLhdIJW6U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)