UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x8GxpVpR9q50sJduYLcaX1RuO9yNaGFTCrYBoo/F2lY='
WHERE
key_id = 'ccba1ebbf817f2322dd90c9faae10af90c0d746ad7a1170dee1b61d7f3046564'
AND (
token = 'x8GxpVpR9q50sJduYLcaX1RuO9yNaGFTCrYBoo/F2lY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)