UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bGJV0+5OGfzG7Y9iJP4wH1gjn9Hbg8KFAyd4f7vnUE0='
WHERE
key_id = 'b176531ce704672f189463aa7f80c21edae09b8076e020972de4a7adacc6d6fd'
AND (
token = 'bGJV0+5OGfzG7Y9iJP4wH1gjn9Hbg8KFAyd4f7vnUE0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)