UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sNHDq09MGfgJPsEcjKNTuoMxQt+rC/ohFltiyi6JOI0='
WHERE
key_id = '0e274a2c9f5fc28920340c24ecc99fee320118c77d68b4a492960479a4641384'
AND (
token = 'sNHDq09MGfgJPsEcjKNTuoMxQt+rC/ohFltiyi6JOI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)