UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3SnvI3UbdPilZbOAajwrMgliD+7ynhndnvAPV8HE8vA='
WHERE
key_id = '1fd411097dabaaf230cff85bddb80a309e65e1830beebb53d4a09b806eb3161b'
AND (
token = '3SnvI3UbdPilZbOAajwrMgliD+7ynhndnvAPV8HE8vA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)