UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AXXx5yDqCfiydhOHhbyeTEd5Tb7YIb0MkP0D6UgtKl0='
WHERE
key_id = 'de7bf3a98fa8dfdf6b020daae6a8ff681dfdbd4251b148a6ae69c8c7e2cf49eb'
AND (
token = 'AXXx5yDqCfiydhOHhbyeTEd5Tb7YIb0MkP0D6UgtKl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)