UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ERVCADYhZK1oydulSLjd/9fSFfVHiiqfDY503B8dSw='
WHERE
key_id = 'e196952727327904fe6ce77f08ce8f0d95fa710d93b939e36279823175df01ee'
AND (
token = '0ERVCADYhZK1oydulSLjd/9fSFfVHiiqfDY503B8dSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)