UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nUT1jzb2Fh/nuv5rDhIbU5oscz8z1ZWSlXXdUAjcMaA='
WHERE
key_id = 'ccc1b0e870159bfd8d9acecbc7d7d5dc6897b0c448b02a3edb3f5a2e1b6a2b78'
AND (
token = 'nUT1jzb2Fh/nuv5rDhIbU5oscz8z1ZWSlXXdUAjcMaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)