UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HOB6ahP7om80rVpa74iWcr3yqys/Bxie5cfJUjJVx84=' 
WHERE 
  key_id = 'e10902b617c86e7e978890f9c2d5bbb297e5ad6c8d419c6c8c425a310a3adcd4' 
  AND (
    token = 'HOB6ahP7om80rVpa74iWcr3yqys/Bxie5cfJUjJVx84=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032