UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lh6BJwl7eoLycWt8pZtgV5/4rZFpscwzM+jfBCtaIMY='
WHERE
key_id = '2c9a7e2737084e22b15cc57d299c1176bddf0e6dcf9f71c1d5e983770997dd0e'
AND (
token = 'Lh6BJwl7eoLycWt8pZtgV5/4rZFpscwzM+jfBCtaIMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)