UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bWbCN/oF1xM57sAB30wiju+44V4I+6vrtq0TkPWQnoE='
WHERE
key_id = '9c04311d64133be672979fe3b5de50fb6b2b4b36c02e74efb59b253dbf249984'
AND (
token = 'bWbCN/oF1xM57sAB30wiju+44V4I+6vrtq0TkPWQnoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)