UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BcG3UlUbcs/kVSJH7giedX7bOC2pe6chZlZFB6gkGZY='
WHERE
key_id = 'c4fd5e82174e4bf4dc612910843fe53b801773ba4ab04bbe36dad6e947ec42f4'
AND (
token = 'BcG3UlUbcs/kVSJH7giedX7bOC2pe6chZlZFB6gkGZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)