UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8zLUX3Y6kQXVo2vIaymQrUt9jhkZi1NlvDODUOagdLs='
WHERE
key_id = '79e285fb60d6df75e7e8941ba0cd857d1c29a146df272f0c4a04448882812b5b'
AND (
token = '8zLUX3Y6kQXVo2vIaymQrUt9jhkZi1NlvDODUOagdLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)