UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+JPd30/q9QP4+f7z2aypahhK/Mj407rR4l8C+cYsk6w=' 
WHERE 
  key_id = 'a38bb6788d1bb5fde2f500a2a06c2a82a7083db077489ad326812d2bbe96eb2a' 
  AND (
    token = '+JPd30/q9QP4+f7z2aypahhK/Mj407rR4l8C+cYsk6w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046