UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/ovseya5dg9FBNgBKRpsoM4i5QDfGLznK/LhgVcAjko=' 
WHERE 
  key_id = 'f839fe81775a9b715825378ab1c933b801a9e406d00fee46bf5e86c67a5dc26a' 
  AND (
    token = '/ovseya5dg9FBNgBKRpsoM4i5QDfGLznK/LhgVcAjko=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041