UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCOBjQX1OCf2Rusrt+MF3idUhCAJPTJEtG8Iqv7Pulg='
WHERE
key_id = '6e404de465b866c13cf7680d31a8e8e1b7d744923bd7c2f8109d5ea4668426ca'
AND (
token = 'QCOBjQX1OCf2Rusrt+MF3idUhCAJPTJEtG8Iqv7Pulg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)