UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MCXQ38963Q1GyOAI9/q76caYSsFxlC7k+LHjKdSUDpA='
WHERE
key_id = 'bc3c0c42d14fefc37ca4ad02ddc778d6f7777f3a99b0dedef4a702b8c53f133c'
AND (
token = 'MCXQ38963Q1GyOAI9/q76caYSsFxlC7k+LHjKdSUDpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)