UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HPuQpkBx3C2IYIzb7CX2W/ext3JapTp5Nk6j4jdDFJY='
WHERE
key_id = '904535d8aec3bc93e72910ef796d1cd7a53f4e55ad6597b72c0c0f61c852ca06'
AND (
token = 'HPuQpkBx3C2IYIzb7CX2W/ext3JapTp5Nk6j4jdDFJY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)