UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oCAMz0eoKcbbClbzCtDqOtFqIOOusGOjFWZEjRsr/JQ='
WHERE
key_id = 'c81faa8975c67b6d80be646c92eea39f24cfa35d3024bc31040185404cd4bdcc'
AND (
token = 'oCAMz0eoKcbbClbzCtDqOtFqIOOusGOjFWZEjRsr/JQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)