UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'P3aLpQ5bhG5ewY4JRTbLp2b+ZSOIyuFGE/r9QhsVMDs=' 
WHERE 
  key_id = '78e6703e6a2e4e9bf1edca346bcc241ef4a66e9903d02dc73de7c4ba08934048' 
  AND (
    token = 'P3aLpQ5bhG5ewY4JRTbLp2b+ZSOIyuFGE/r9QhsVMDs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032