UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+64bGpVhwkWu5PxU5SNnEwWAj+qVtSUIskmfxnWEgDY='
WHERE
key_id = 'ee4f6c7c364b13df69f30c9e39dd92263b5aafa26b20b2c64677ef42fb19b065'
AND (
token = '+64bGpVhwkWu5PxU5SNnEwWAj+qVtSUIskmfxnWEgDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)