UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gsTjAYI+GNPEmbqqRaD7NOL2QwsPEIn6ShM8YqC+9bI='
WHERE
key_id = '0b47007b954383a7fd381233c0e85382bc1b4e553ce0b41ff6fb99f4a56f391e'
AND (
token = 'gsTjAYI+GNPEmbqqRaD7NOL2QwsPEIn6ShM8YqC+9bI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)