UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hL/+D94CC2KE06e/m7+sZ1GM/y3EY/ChB+A8u5DuFO4=' 
WHERE 
  key_id = '25e7f352892d02eb60521fe37e9666a7baa61bf25bb1f403c2ec068a4535eb4d' 
  AND (
    token = 'hL/+D94CC2KE06e/m7+sZ1GM/y3EY/ChB+A8u5DuFO4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026