UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eMagSyCErQ4nk8lJzDels9osY0eyb+mZf9ZxNTId8Uw='
WHERE
key_id = 'e8af9e3751ba59cbb7fda014cfadf8ff9377edfe00a3bcfca43bc6c814dc3204'
AND (
token = 'eMagSyCErQ4nk8lJzDels9osY0eyb+mZf9ZxNTId8Uw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)