UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q0rFqS8jHBur+ZSk++UwJt0HXDYQj1bnf9V2/B7wQdw='
WHERE
key_id = 'ef1b8790440abc9f64b470d35f59904775c4ad672497988301bab56c8abcf2e4'
AND (
token = 'q0rFqS8jHBur+ZSk++UwJt0HXDYQj1bnf9V2/B7wQdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)