UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'uY1th2Pu+FJPGVNi7AEJh5tRMwk75c0sIZ25Qg9Cbns=' 
WHERE 
  key_id = '4cba59b891c2d101de901db01bcce2edf9edc4a0074b6e9af52195525070e8ab' 
  AND (
    token = 'uY1th2Pu+FJPGVNi7AEJh5tRMwk75c0sIZ25Qg9Cbns=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00098